package com.fowo.api.model.tmp.fba.inventory;

import com.alibaba.excel.annotation.ExcelIgnore;
import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.write.style.ContentStyle;
import com.alibaba.excel.enums.poi.HorizontalAlignmentEnum;
import com.fowo.api.common.excel.ImageConvert;
import com.fowo.api.common.validator.EnumsString;
import com.fowo.api.sys.entity.SysFile;
import java.util.List;
import javax.validation.constraints.*;
import lombok.Getter;
import lombok.Setter;

/** FBA库存临时表 导入导出辅助模型 */
@Getter
@Setter
public class TmpFbaInventoryExcelPo {

  @Size(max = 50, message = "仓库长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "仓库")
  private String warehouseName;

  @ExcelIgnore
  @ExcelProperty(value = "仓库")
  private Long warehouse;

  @Size(max = 50, message = "图片长度不能超过20")
  @ExcelProperty(value = "图片", converter = ImageConvert.class)
  private List<SysFile> picture;

  @Size(max = 50, message = "ASIN长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "ASIN")
  private String asin;

  @Size(max = 50, message = "MSKU长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "MSKU")
  private String msku;

  @Size(max = 50, message = "FNSKU长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "FNSKU")
  private String fnsku;

  @Size(max = 50, message = "品名长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "品名")
  private String productIdName;

  @ExcelIgnore
  @ExcelProperty(value = "品名")
  private Long productId;

  @Size(max = 50, message = "SKU长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "SKU")
  private String sku;

  @Size(max = 50, message = "负责人长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "负责人")
  private String headName;

  @ExcelIgnore
  @ExcelProperty(value = "负责人")
  private List<Long> head;

  @Size(max = 50, message = "总库存长度不能超过20")
  @ExcelProperty(value = "总库存")
  private Integer totalInventory;

  @ExcelProperty(value = "可用库存")
  private Integer availableStock;

  @ExcelProperty(value = "FBA可售")
  private Integer fbaAvailableForSale;

  @ExcelProperty(value = "FBM可售")
  private Integer fbmAvailableForSale;

  @ExcelProperty(value = "待调仓")
  private Integer warehouseToBeAdjusted;

  @ExcelProperty(value = "调仓中")
  private Integer duringWarehouseAdjustment;

  @ExcelProperty(value = "待发货")
  private Integer toBeShipped;

  @ExcelProperty(value = "计划入库")
  private Integer plannedWarehousing;

  @ExcelProperty(value = "标发在途")
  private Integer standardInTransit;

  @ExcelProperty(value = "实际在途")
  private Integer actualInTransit;

  @ExcelProperty(value = "入库中")
  private Integer inStorage;

  @ExcelProperty(value = "不可售")
  private Integer notAvailableForSale;

  @ExcelProperty(value = "调查中")
  private Integer underInvestigation;

  @EnumsString(
    value = { "是", "否·" },
    message = "预警状态的可用值为 “是”, “否·” 其中之一"
  )
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "预警状态")
  private String warningStatus;

  @ExcelProperty(value = "0-30天库龄")
  private Integer day30;

  @ExcelProperty(value = "31-60天库龄")
  private Integer day60;

  @ExcelProperty(value = "61-90天库龄")
  private Integer day90;

  @ExcelProperty(value = "91-180天库龄")
  private Integer day180;

  @ExcelProperty(value = "181-270天库龄")
  private Integer day270;

  @ExcelProperty(value = "271-330天库龄")
  private Integer day330;

  @ExcelProperty(value = "331-365天库龄")
  private Integer day365;

  @ExcelProperty(value = "365天以上库龄")
  private Integer day366;

  @ExcelProperty(value = "listing主键")
  private Long listingId;

  @Size(max = 50, message = "配送类型长度不能超过20")
  @ContentStyle(
    horizontalAlignment = HorizontalAlignmentEnum.LEFT,
    dataFormat = 49
  )
  @ExcelProperty(value = "配送类型")
  private String fulfillmentChannelType;

  @Size(max = 50, message = "店铺长度不能超过20")
  @ExcelProperty(value = "店铺")
  private Long sid;

  @ExcelProperty(value = "采购成本")
  private java.math.BigDecimal cost;
}
